Tabela LAccountDataStatus

Definicja tabeli LAccountDataStatus

Name

LAccountDataStatus

Code

LAccountDataStatus

Comment

 


Lista kolumn tabeli LAccountDataStatus

Name

Code

AccountDataStatusID

AccountDataStatusID

StatusID

StatusID

MessageID

MessageID

AccountTemplateID

AccountTemplateID

AccountDataID

AccountDataID

EventID

EventID

EpisodeID

EpisodeID

AccountDataVersionNo

AccountDataVersionNo

PerfDT

PerfDT

ServiceSetVersionNo

ServiceSetVersionNo

UnitsCount

UnitsCount

Price

Price

ToVeryfication

ToVeryfication

VeryficationDate

VeryficationDate

nfzImportStatus

nfzImportStatus

nfzValidationStatus

nfzValidationStatus

nfzAccountDataImportStatus

nfzAccountDataImportStatus

EpisodeAccountVersionNo

EpisodeAccountVersionNo

CorrectionReason

CorrectionReason

NfzDelEpisodeVersionNo

NfzDelEpisodeVersionNo

NfzDelEpisodeAccVersionNo

NfzDelEpisodeAccVersionNo

NfzVerifyStatus

NfzVerifyStatus

ParentAccountDataID

ParentAccountDataID

LAccountDataStatus

LAccountDataStatus


Kolumna AccountDataStatusID tabeli LAccountDataStatus

Definicja kolumny AccountDataStatusID tabeli LAccountDataStatus

Name

AccountDataStatusID

Code

AccountDataStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StatusID tabeli LAccountDataStatus

Definicja kolumny StatusID tabeli LAccountDataStatus

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MessageID tabeli LAccountDataStatus

Definicja kolumny MessageID tabeli LAccountDataStatus

Name

MessageID

Code

MessageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountTemplateID tabeli LAccountDataStatus

Definicja kolumny AccountTemplateID tabeli LAccountDataStatus

Name

AccountTemplateID

Code

AccountTemplateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountDataID tabeli LAccountDataStatus

Definicja kolumny AccountDataID tabeli LAccountDataStatus

Name

AccountDataID

Code

AccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli LAccountDataStatus

Definicja kolumny EventID tabeli LAccountDataStatus

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli LAccountDataStatus

Definicja kolumny EpisodeID tabeli LAccountDataStatus

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(20)

Mandatory

No

Comment

 


Kolumna AccountDataVersionNo tabeli LAccountDataStatus

Definicja kolumny AccountDataVersionNo tabeli LAccountDataStatus

Name

AccountDataVersionNo

Code

AccountDataVersionNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli LAccountDataStatus

Definicja kolumny PerfDT tabeli LAccountDataStatus

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ServiceSetVersionNo tabeli LAccountDataStatus

Definicja kolumny ServiceSetVersionNo tabeli LAccountDataStatus

Name

ServiceSetVersionNo

Code

ServiceSetVersionNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli LAccountDataStatus

Definicja kolumny UnitsCount tabeli LAccountDataStatus

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna Price tabeli LAccountDataStatus

Definicja kolumny Price tabeli LAccountDataStatus

Name

Price

Code

Price

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna ToVeryfication tabeli LAccountDataStatus

Definicja kolumny ToVeryfication tabeli LAccountDataStatus

Name

ToVeryfication

Code

ToVeryfication

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna VeryficationDate tabeli LAccountDataStatus

Definicja kolumny VeryficationDate tabeli LAccountDataStatus

Name

VeryficationDate

Code

VeryficationDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna nfzImportStatus tabeli LAccountDataStatus

Definicja kolumny nfzImportStatus tabeli LAccountDataStatus

Name

nfzImportStatus

Code

nfzImportStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna nfzValidationStatus tabeli LAccountDataStatus

Definicja kolumny nfzValidationStatus tabeli LAccountDataStatus

Name

nfzValidationStatus

Code

nfzValidationStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna nfzAccountDataImportStatus tabeli LAccountDataStatus

Definicja kolumny nfzAccountDataImportStatus tabeli LAccountDataStatus

Name

nfzAccountDataImportStatus

Code

nfzAccountDataImportStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna EpisodeAccountVersionNo tabeli LAccountDataStatus

Definicja kolumny EpisodeAccountVersionNo tabeli LAccountDataStatus

Name

EpisodeAccountVersionNo

Code

EpisodeAccountVersionNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CorrectionReason tabeli LAccountDataStatus

Definicja kolumny CorrectionReason tabeli LAccountDataStatus

Name

CorrectionReason

Code

CorrectionReason

Data Type

VARCHAR2(3)

Mandatory

No

Comment

Kod przyczyny korekty, zwiazane z wprowadzeniem nowego sposobu rozliczania
korekt pozycji rozliczeniowych (przyjmowane wartosci:'01','02','03','04')


Kolumna NfzDelEpisodeVersionNo tabeli LAccountDataStatus

Definicja kolumny NfzDelEpisodeVersionNo tabeli LAccountDataStatus

Name

NfzDelEpisodeVersionNo

Code

NfzDelEpisodeVersionNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna NfzDelEpisodeAccVersionNo tabeli LAccountDataStatus

Definicja kolumny NfzDelEpisodeAccVersionNo tabeli LAccountDataStatus

Name

NfzDelEpisodeAccVersionNo

Code

NfzDelEpisodeAccVersionNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna NfzVerifyStatus tabeli LAccountDataStatus

Definicja kolumny NfzVerifyStatus tabeli LAccountDataStatus

Name

NfzVerifyStatus

Code

NfzVerifyStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ParentAccountDataID tabeli LAccountDataStatus

Definicja kolumny ParentAccountDataID tabeli LAccountDataStatus

Name

ParentAccountDataID

Code

ParentAccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LAccountDataStatus tabeli LAccountDataStatus

Definicja kolumny LAccountDataStatus tabeli LAccountDataStatus

Name

LAccountDataStatus

Code

LAccountDataStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli LAccountDataStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LAccountDataStatus

Definicja klucza Identifier_1 tabeli LAccountDataStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment